<?php
include "db.php";
$statee=$_REQUEST['estado'];
$sql="SELECT stc.club_number, stc.club_name FROM st_club stc WHERE estado_id='$statee' ORDER BY stc.club_name";
				$result = mysql_query($sql) or die( mysql_error());	
				echo"Club: <select name='club_es' id='club_es'>";
				while ($fila = mysql_fetch_assoc($result)) {
				echo"<option value='". $fila['club_number'] ."'>". $fila['club_name'] ."</option>";
				}
				echo"</select>";
?>
<center><div id="ajax2"></div></center>
<script type="text/javascript" >
$(function () {
		$('#club_es').click(function()
	{
		$('#ajax2').load('asig_club3.php?clubes=' + this.options[this.selectedIndex].value)
	})	
})
</script>